Release 10.1A: OpenEdge Data Management:
SQL Reference

CURTIME

Returns the current time as a TIME value. This function takes no arguments.

Syntax

CURTIME ( )

Example

This example illustrates how to use the CURTIME function to INSERT the current time into the create_time column of the objects table:

INSERT INTO objects (object_owner, object_id, create_time) VALUES (USER, 1001, CURTIME()) ;

Note

SQL statements can refer to CURTIME anywhere they can refer to a TIME expression.

Compatibility

ODBC compatible

See also

SYSTIME function